<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- NewPage -->
<html lang="en">
<head>
<title>CellStyle (POI API Documentation)</title>
<link rel="stylesheet" type="text/css" href="../../../../../stylesheet.css" title="Style">
</head>
<body>
<script type="text/javascript"><!--
    if (location.href.indexOf('is-external=true') == -1) {
        parent.document.title="CellStyle (POI API Documentation)";
    }
//-->
</script>
<noscript>
<div>JavaScript is disabled on your browser.</div>
</noscript>
<!-- ========= START OF TOP NAVBAR ======= -->
<div class="topNav"><a name="navbar_top">
<!--   -->
</a><a href="#skip-navbar_top" title="Skip navigation links"></a><a name="navbar_top_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/CellStyle.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/ss/usermodel/CellValue.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/CellStyle.html" target="_top">FRAMES</a></li>
<li><a href="CellStyle.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_top">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_top");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li>CONSTR&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li>CONSTR&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_top">
<!--   -->
</a></div>
<!-- ========= END OF TOP NAVBAR ========= -->
<!-- ======== START OF CLASS DATA ======== -->
<div class="header">
<p class="subTitle">org.apache.poi.ss.usermodel</p>
<h2 title="Interface CellStyle" class="title">Interface CellStyle</h2>
</div>
<div class="contentContainer">
<div class="description">
<ul class="blockList">
<li class="blockList">
<dl>
<dt>All Known Implementing Classes:</dt>
<dd><a href="../../../../../org/apache/poi/hssf/usermodel/HSSFCellStyle.html" title="class in org.apache.poi.hssf.usermodel">HSSFCellStyle</a>, <a href="../../../../../org/apache/poi/xssf/usermodel/XSSFCellStyle.html" title="class in org.apache.poi.xssf.usermodel">XSSFCellStyle</a></dd>
</dl>
<hr>
<br>
<pre>public interface <strong>CellStyle</strong></pre>
</li>
</ul>
</div>
<div class="summary">
<ul class="blockList">
<li class="blockList">
<!-- =========== FIELD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_summary">
<!--   -->
</a>
<h3>Field Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Field Summary table, listing fields, and an explanation">
<caption><span>Fields</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Field and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER">ALIGN_CENTER</a></strong></code>
<div class="block">center horizontal alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION">ALIGN_CENTER_SELECTION</a></strong></code>
<div class="block">center-selection? horizontal alignment</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL">ALIGN_FILL</a></strong></code>
<div class="block">fill? horizontal alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL">ALIGN_GENERAL</a></strong></code>
<div class="block">general (normal) horizontal alignment</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY">ALIGN_JUSTIFY</a></strong></code>
<div class="block">justified horizontal alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT">ALIGN_LEFT</a></strong></code>
<div class="block">left-justified horizontal alignment</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT">ALIGN_RIGHT</a></strong></code>
<div class="block">right-justified horizontal alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS">ALT_BARS</a></strong></code>
<div class="block">Wide dots</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS">BIG_SPOTS</a></strong></code>
<div class="block">Large spots</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT">BORDER_DASH_DOT</a></strong></code>
<div class="block">dash-dot border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT">BORDER_DASH_DOT_DOT</a></strong></code>
<div class="block">dash-dot-dot border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED">BORDER_DASHED</a></strong></code>
<div class="block">dash border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED">BORDER_DOTTED</a></strong></code>
<div class="block">hair-line border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE">BORDER_DOUBLE</a></strong></code>
<div class="block">double-line border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR">BORDER_HAIR</a></strong></code>
<div class="block">dot border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM">BORDER_MEDIUM</a></strong></code>
<div class="block">Medium border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT">BORDER_MEDIUM_DASH_DOT</a></strong></code>
<div class="block">medium dash-dot border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT">BORDER_MEDIUM_DASH_DOT_DOT</a></strong></code>
<div class="block">medium dash-dot-dot border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED">BORDER_MEDIUM_DASHED</a></strong></code>
<div class="block">Medium dashed border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE">BORDER_NONE</a></strong></code>
<div class="block">No border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT">BORDER_SLANTED_DASH_DOT</a></strong></code>
<div class="block">slanted dash-dot border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK">BORDER_THICK</a></strong></code>
<div class="block">Thick border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN">BORDER_THIN</a></strong></code>
<div class="block">Thin border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS">BRICKS</a></strong></code>
<div class="block">Brick-like layout</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS">DIAMONDS</a></strong></code>
<div class="block">Diamonds</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS">FINE_DOTS</a></strong></code>
<div class="block">Small fine dots</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LEAST_DOTS">LEAST_DOTS</a></strong></code>
<div class="block">Least Dots</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#LESS_DOTS">LESS_DOTS</a></strong></code>
<div class="block">Less Dots</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL">NO_FILL</a></strong></code>
<div class="block">No background</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND">SOLID_FOREGROUND</a></strong></code>
<div class="block">Solidly filled</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS">SPARSE_DOTS</a></strong></code>
<div class="block">Sparse dots</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES">SQUARES</a></strong></code>
<div class="block">Squares</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG">THICK_BACKWARD_DIAG</a></strong></code>
<div class="block">Thick backward facing diagonals</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG">THICK_FORWARD_DIAG</a></strong></code>
<div class="block">Thick forward facing diagonals</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS">THICK_HORZ_BANDS</a></strong></code>
<div class="block">Thick horizontal bands</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS">THICK_VERT_BANDS</a></strong></code>
<div class="block">Thick vertical bands</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG">THIN_BACKWARD_DIAG</a></strong></code>
<div class="block">Thin backward diagonal</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG">THIN_FORWARD_DIAG</a></strong></code>
<div class="block">Thin forward diagonal</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS">THIN_HORZ_BANDS</a></strong></code>
<div class="block">Thin horizontal bands</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS">THIN_VERT_BANDS</a></strong></code>
<div class="block">Thin vertical bands</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM">VERTICAL_BOTTOM</a></strong></code>
<div class="block">bottom-aligned vertical alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER">VERTICAL_CENTER</a></strong></code>
<div class="block">center-aligned vertical alignment</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY">VERTICAL_JUSTIFY</a></strong></code>
<div class="block">vertically justified vertical alignment</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>static short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP">VERTICAL_TOP</a></strong></code>
<div class="block">top-aligned vertical alignment</div>
</td>
</tr>
</table>
</li>
</ul>
<!-- ========== METHOD SUMMARY =========== -->
<ul class="blockList">
<li class="blockList"><a name="method_summary">
<!--   -->
</a>
<h3>Method Summary</h3>
<table class="overviewSummary" border="0" cellpadding="3" cellspacing="0" summary="Method Summary table, listing methods, and an explanation">
<caption><span>Methods</span><span class="tabEnd">&nbsp;</span></caption>
<tr>
<th class="colFirst" scope="col">Modifier and Type</th>
<th class="colLast" scope="col">Method and Description</th>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">cloneStyleFrom</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;source)</code>
<div class="block">Clones all the style information from another
  CellStyle, onto this one.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getAlignment()">getAlignment</a></strong>()</code>
<div class="block">get the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderBottom()">getBorderBottom</a></strong>()</code>
<div class="block">get the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderLeft()">getBorderLeft</a></strong>()</code>
<div class="block">get the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderRight()">getBorderRight</a></strong>()</code>
<div class="block">get the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBorderTop()">getBorderTop</a></strong>()</code>
<div class="block">get the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getBottomBorderColor()">getBottomBorderColor</a></strong>()</code>
<div class="block">get the color to use for the left border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormat()">getDataFormat</a></strong>()</code>
<div class="block">get the index of the format</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>java.lang.String</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getDataFormatString()">getDataFormatString</a></strong>()</code>
<div class="block">Get the format string</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColor()">getFillBackgroundColor</a></strong>()</code>
<div class="block">get the background fill color, if the fill
  is defined with an indexed color.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Color.html" title="interface in org.apache.poi.ss.usermodel">Color</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillBackgroundColorColor()">getFillBackgroundColorColor</a></strong>()</code>
<div class="block">Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColor()">getFillForegroundColor</a></strong>()</code>
<div class="block">get the foreground fill color, if the fill  
  is defined with an indexed color.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code><a href="../../../../../org/apache/poi/ss/usermodel/Color.html" title="interface in org.apache.poi.ss.usermodel">Color</a></code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillForegroundColorColor()">getFillForegroundColorColor</a></strong>()</code>
<div class="block">Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFillPattern()">getFillPattern</a></strong>()</code>
<div class="block">get the fill pattern (??) - set to 1 to fill with foreground color</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getFontIndex()">getFontIndex</a></strong>()</code>
<div class="block">gets the index of the font for this style</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getHidden()">getHidden</a></strong>()</code>
<div class="block">get whether the cell's using this style are to be hidden</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndention()">getIndention</a></strong>()</code>
<div class="block">get the number of spaces to indent the text in the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getIndex()">getIndex</a></strong>()</code>
<div class="block">get the index within the Workbook (sequence within the collection of ExtnededFormat objects)</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLeftBorderColor()">getLeftBorderColor</a></strong>()</code>
<div class="block">get the color to use for the left border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getLocked()">getLocked</a></strong>()</code>
<div class="block">get whether the cell's using this style are to be locked</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRightBorderColor()">getRightBorderColor</a></strong>()</code>
<div class="block">get the color to use for the left border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getRotation()">getRotation</a></strong>()</code>
<div class="block">get the degree of rotation for the text in the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getShrinkToFit()">getShrinkToFit</a></strong>()</code>
<div class="block">Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getTopBorderColor()">getTopBorderColor</a></strong>()</code>
<div class="block">get the color to use for the top border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>short</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getVerticalAlignment()">getVerticalAlignment</a></strong>()</code>
<div class="block">get the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>boolean</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#getWrapText()">getWrapText</a></strong>()</code>
<div class="block">get whether the text should be wrapped</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setAlignment(short)">setAlignment</a></strong>(short&nbsp;align)</code>
<div class="block">set the type of horizontal alignment for the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderBottom(short)">setBorderBottom</a></strong>(short&nbsp;border)</code>
<div class="block">set the type of border to use for the bottom border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderLeft(short)">setBorderLeft</a></strong>(short&nbsp;border)</code>
<div class="block">set the type of border to use for the left border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderRight(short)">setBorderRight</a></strong>(short&nbsp;border)</code>
<div class="block">set the type of border to use for the right border of the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBorderTop(short)">setBorderTop</a></strong>(short&nbsp;border)</code>
<div class="block">set the type of border to use for the top border of the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setBottomBorderColor(short)">setBottomBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">set the color to use for the bottom border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setDataFormat(short)">setDataFormat</a></strong>(short&nbsp;fmt)</code>
<div class="block">set the data format (must be a valid format)</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillBackgroundColor(short)">setFillBackgroundColor</a></strong>(short&nbsp;bg)</code>
<div class="block">set the background fill color.</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillForegroundColor(short)">setFillForegroundColor</a></strong>(short&nbsp;bg)</code>
<div class="block">set the foreground fill color
 <i>Note: Ensure Foreground color is set prior to background color.</i></div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFillPattern(short)">setFillPattern</a></strong>(short&nbsp;fp)</code>
<div class="block">setting to one fills the cell with the foreground color...</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setFont(org.apache.poi.ss.usermodel.Font)">setFont</a></strong>(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</code>
<div class="block">set the font for this style</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setHidden(boolean)">setHidden</a></strong>(boolean&nbsp;hidden)</code>
<div class="block">set the cell's using this style to be hidden</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setIndention(short)">setIndention</a></strong>(short&nbsp;indent)</code>
<div class="block">set the number of spaces to indent the text in the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLeftBorderColor(short)">setLeftBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">set the color to use for the left border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setLocked(boolean)">setLocked</a></strong>(boolean&nbsp;locked)</code>
<div class="block">set the cell's using this style to be locked</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRightBorderColor(short)">setRightBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">set the color to use for the right border</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setRotation(short)">setRotation</a></strong>(short&nbsp;rotation)</code>
<div class="block">set the degree of rotation for the text in the cell</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setShrinkToFit(boolean)">setShrinkToFit</a></strong>(boolean&nbsp;shrinkToFit)</code>
<div class="block">Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setTopBorderColor(short)">setTopBorderColor</a></strong>(short&nbsp;color)</code>
<div class="block">set the color to use for the top border</div>
</td>
</tr>
<tr class="rowColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setVerticalAlignment(short)">setVerticalAlignment</a></strong>(short&nbsp;align)</code>
<div class="block">set the type of vertical alignment for the cell</div>
</td>
</tr>
<tr class="altColor">
<td class="colFirst"><code>void</code></td>
<td class="colLast"><code><strong><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#setWrapText(boolean)">setWrapText</a></strong>(boolean&nbsp;wrapped)</code>
<div class="block">Set whether the text should be wrapped.</div>
</td>
</tr>
</table>
</li>
</ul>
</li>
</ul>
</div>
<div class="details">
<ul class="blockList">
<li class="blockList">
<!-- ============ FIELD DETAIL =========== -->
<ul class="blockList">
<li class="blockList"><a name="field_detail">
<!--   -->
</a>
<h3>Field Detail</h3>
<a name="ALIGN_GENERAL">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_GENERAL</h4>
<pre>static final&nbsp;short ALIGN_GENERAL</pre>
<div class="block">general (normal) horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_GENERAL">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_LEFT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_LEFT</h4>
<pre>static final&nbsp;short ALIGN_LEFT</pre>
<div class="block">left-justified horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_LEFT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_CENTER">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_CENTER</h4>
<pre>static final&nbsp;short ALIGN_CENTER</pre>
<div class="block">center horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_CENTER">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_RIGHT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_RIGHT</h4>
<pre>static final&nbsp;short ALIGN_RIGHT</pre>
<div class="block">right-justified horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_RIGHT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_FILL">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_FILL</h4>
<pre>static final&nbsp;short ALIGN_FILL</pre>
<div class="block">fill? horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_FILL">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_JUSTIFY">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_JUSTIFY</h4>
<pre>static final&nbsp;short ALIGN_JUSTIFY</pre>
<div class="block">justified horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_JUSTIFY">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALIGN_CENTER_SELECTION">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALIGN_CENTER_SELECTION</h4>
<pre>static final&nbsp;short ALIGN_CENTER_SELECTION</pre>
<div class="block">center-selection? horizontal alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALIGN_CENTER_SELECTION">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="VERTICAL_TOP">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VERTICAL_TOP</h4>
<pre>static final&nbsp;short VERTICAL_TOP</pre>
<div class="block">top-aligned vertical alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_TOP">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="VERTICAL_CENTER">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VERTICAL_CENTER</h4>
<pre>static final&nbsp;short VERTICAL_CENTER</pre>
<div class="block">center-aligned vertical alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_CENTER">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="VERTICAL_BOTTOM">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VERTICAL_BOTTOM</h4>
<pre>static final&nbsp;short VERTICAL_BOTTOM</pre>
<div class="block">bottom-aligned vertical alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_BOTTOM">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="VERTICAL_JUSTIFY">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>VERTICAL_JUSTIFY</h4>
<pre>static final&nbsp;short VERTICAL_JUSTIFY</pre>
<div class="block">vertically justified vertical alignment</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.VERTICAL_JUSTIFY">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_NONE">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_NONE</h4>
<pre>static final&nbsp;short BORDER_NONE</pre>
<div class="block">No border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_NONE">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_THIN">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_THIN</h4>
<pre>static final&nbsp;short BORDER_THIN</pre>
<div class="block">Thin border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_THIN">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_MEDIUM">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_MEDIUM</h4>
<pre>static final&nbsp;short BORDER_MEDIUM</pre>
<div class="block">Medium border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_DASHED">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_DASHED</h4>
<pre>static final&nbsp;short BORDER_DASHED</pre>
<div class="block">dash border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASHED">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_HAIR">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_HAIR</h4>
<pre>static final&nbsp;short BORDER_HAIR</pre>
<div class="block">dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_HAIR">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_THICK">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_THICK</h4>
<pre>static final&nbsp;short BORDER_THICK</pre>
<div class="block">Thick border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_THICK">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_DOUBLE">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_DOUBLE</h4>
<pre>static final&nbsp;short BORDER_DOUBLE</pre>
<div class="block">double-line border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DOUBLE">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_DOTTED">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_DOTTED</h4>
<pre>static final&nbsp;short BORDER_DOTTED</pre>
<div class="block">hair-line border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DOTTED">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_MEDIUM_DASHED">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_MEDIUM_DASHED</h4>
<pre>static final&nbsp;short BORDER_MEDIUM_DASHED</pre>
<div class="block">Medium dashed border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASHED">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_DASH_DOT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_DASH_DOT</h4>
<pre>static final&nbsp;short BORDER_DASH_DOT</pre>
<div class="block">dash-dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASH_DOT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_MEDIUM_DASH_DOT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_MEDIUM_DASH_DOT</h4>
<pre>static final&nbsp;short BORDER_MEDIUM_DASH_DOT</pre>
<div class="block">medium dash-dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASH_DOT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_DASH_DOT_DOT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_DASH_DOT_DOT</h4>
<pre>static final&nbsp;short BORDER_DASH_DOT_DOT</pre>
<div class="block">dash-dot-dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_DASH_DOT_DOT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_MEDIUM_DASH_DOT_DOT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_MEDIUM_DASH_DOT_DOT</h4>
<pre>static final&nbsp;short BORDER_MEDIUM_DASH_DOT_DOT</pre>
<div class="block">medium dash-dot-dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_MEDIUM_DASH_DOT_DOT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BORDER_SLANTED_DASH_DOT">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BORDER_SLANTED_DASH_DOT</h4>
<pre>static final&nbsp;short BORDER_SLANTED_DASH_DOT</pre>
<div class="block">slanted dash-dot border</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BORDER_SLANTED_DASH_DOT">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="NO_FILL">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>NO_FILL</h4>
<pre>static final&nbsp;short NO_FILL</pre>
<div class="block">No background</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.NO_FILL">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="SOLID_FOREGROUND">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SOLID_FOREGROUND</h4>
<pre>static final&nbsp;short SOLID_FOREGROUND</pre>
<div class="block">Solidly filled</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SOLID_FOREGROUND">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="FINE_DOTS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>FINE_DOTS</h4>
<pre>static final&nbsp;short FINE_DOTS</pre>
<div class="block">Small fine dots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.FINE_DOTS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="ALT_BARS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>ALT_BARS</h4>
<pre>static final&nbsp;short ALT_BARS</pre>
<div class="block">Wide dots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.ALT_BARS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="SPARSE_DOTS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SPARSE_DOTS</h4>
<pre>static final&nbsp;short SPARSE_DOTS</pre>
<div class="block">Sparse dots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SPARSE_DOTS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THICK_HORZ_BANDS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THICK_HORZ_BANDS</h4>
<pre>static final&nbsp;short THICK_HORZ_BANDS</pre>
<div class="block">Thick horizontal bands</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_HORZ_BANDS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THICK_VERT_BANDS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THICK_VERT_BANDS</h4>
<pre>static final&nbsp;short THICK_VERT_BANDS</pre>
<div class="block">Thick vertical bands</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_VERT_BANDS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THICK_BACKWARD_DIAG">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THICK_BACKWARD_DIAG</h4>
<pre>static final&nbsp;short THICK_BACKWARD_DIAG</pre>
<div class="block">Thick backward facing diagonals</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_BACKWARD_DIAG">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THICK_FORWARD_DIAG">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THICK_FORWARD_DIAG</h4>
<pre>static final&nbsp;short THICK_FORWARD_DIAG</pre>
<div class="block">Thick forward facing diagonals</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THICK_FORWARD_DIAG">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BIG_SPOTS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BIG_SPOTS</h4>
<pre>static final&nbsp;short BIG_SPOTS</pre>
<div class="block">Large spots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BIG_SPOTS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="BRICKS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>BRICKS</h4>
<pre>static final&nbsp;short BRICKS</pre>
<div class="block">Brick-like layout</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.BRICKS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THIN_HORZ_BANDS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THIN_HORZ_BANDS</h4>
<pre>static final&nbsp;short THIN_HORZ_BANDS</pre>
<div class="block">Thin horizontal bands</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_HORZ_BANDS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THIN_VERT_BANDS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THIN_VERT_BANDS</h4>
<pre>static final&nbsp;short THIN_VERT_BANDS</pre>
<div class="block">Thin vertical bands</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_VERT_BANDS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THIN_BACKWARD_DIAG">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THIN_BACKWARD_DIAG</h4>
<pre>static final&nbsp;short THIN_BACKWARD_DIAG</pre>
<div class="block">Thin backward diagonal</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_BACKWARD_DIAG">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="THIN_FORWARD_DIAG">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>THIN_FORWARD_DIAG</h4>
<pre>static final&nbsp;short THIN_FORWARD_DIAG</pre>
<div class="block">Thin forward diagonal</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.THIN_FORWARD_DIAG">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="SQUARES">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>SQUARES</h4>
<pre>static final&nbsp;short SQUARES</pre>
<div class="block">Squares</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.SQUARES">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="DIAMONDS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>DIAMONDS</h4>
<pre>static final&nbsp;short DIAMONDS</pre>
<div class="block">Diamonds</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.DIAMONDS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="LESS_DOTS">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>LESS_DOTS</h4>
<pre>static final&nbsp;short LESS_DOTS</pre>
<div class="block">Less Dots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.LESS_DOTS">Constant Field Values</a></dd></dl>
</li>
</ul>
<a name="LEAST_DOTS">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>LEAST_DOTS</h4>
<pre>static final&nbsp;short LEAST_DOTS</pre>
<div class="block">Least Dots</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../constant-values.html#org.apache.poi.ss.usermodel.CellStyle.LEAST_DOTS">Constant Field Values</a></dd></dl>
</li>
</ul>
</li>
</ul>
<!-- ============ METHOD DETAIL ========== -->
<ul class="blockList">
<li class="blockList"><a name="method_detail">
<!--   -->
</a>
<h3>Method Detail</h3>
<a name="getIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getIndex</h4>
<pre>short&nbsp;getIndex()</pre>
<div class="block">get the index within the Workbook (sequence within the collection of ExtnededFormat objects)</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>unique index number of the underlying record this style represents (probably you don't care
  unless you're comparing which one is which)</dd></dl>
</li>
</ul>
<a name="setDataFormat(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setDataFormat</h4>
<pre>void&nbsp;setDataFormat(short&nbsp;fmt)</pre>
<div class="block">set the data format (must be a valid format)</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormat.html" title="interface in org.apache.poi.ss.usermodel"><code>DataFormat</code></a></dd></dl>
</li>
</ul>
<a name="getDataFormat()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataFormat</h4>
<pre>short&nbsp;getDataFormat()</pre>
<div class="block">get the index of the format</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/DataFormat.html" title="interface in org.apache.poi.ss.usermodel"><code>DataFormat</code></a></dd></dl>
</li>
</ul>
<a name="getDataFormatString()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getDataFormatString</h4>
<pre>java.lang.String&nbsp;getDataFormatString()</pre>
<div class="block">Get the format string</div>
</li>
</ul>
<a name="setFont(org.apache.poi.ss.usermodel.Font)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFont</h4>
<pre>void&nbsp;setFont(<a href="../../../../../org/apache/poi/ss/usermodel/Font.html" title="interface in org.apache.poi.ss.usermodel">Font</a>&nbsp;font)</pre>
<div class="block">set the font for this style</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>font</code> - a font object created or retreived from the Workbook object</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#createFont()"><code>Workbook.createFont()</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#getFontAt(short)"><code>Workbook.getFontAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="getFontIndex()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFontIndex</h4>
<pre>short&nbsp;getFontIndex()</pre>
<div class="block">gets the index of the font for this style</div>
<dl><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/Workbook.html#getFontAt(short)"><code>Workbook.getFontAt(short)</code></a></dd></dl>
</li>
</ul>
<a name="setHidden(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setHidden</h4>
<pre>void&nbsp;setHidden(boolean&nbsp;hidden)</pre>
<div class="block">set the cell's using this style to be hidden</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>hidden</code> - - whether the cell using this style should be hidden</dd></dl>
</li>
</ul>
<a name="getHidden()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getHidden</h4>
<pre>boolean&nbsp;getHidden()</pre>
<div class="block">get whether the cell's using this style are to be hidden</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>hidden - whether the cell using this style should be hidden</dd></dl>
</li>
</ul>
<a name="setLocked(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setLocked</h4>
<pre>void&nbsp;setLocked(boolean&nbsp;locked)</pre>
<div class="block">set the cell's using this style to be locked</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>locked</code> - - whether the cell using this style should be locked</dd></dl>
</li>
</ul>
<a name="getLocked()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLocked</h4>
<pre>boolean&nbsp;getLocked()</pre>
<div class="block">get whether the cell's using this style are to be locked</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>hidden - whether the cell using this style should be locked</dd></dl>
</li>
</ul>
<a name="setAlignment(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setAlignment</h4>
<pre>void&nbsp;setAlignment(short&nbsp;align)</pre>
<div class="block">set the type of horizontal alignment for the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><code>ALIGN_GENERAL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><code>ALIGN_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><code>ALIGN_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><code>ALIGN_RIGHT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><code>ALIGN_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><code>ALIGN_JUSTIFY</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><code>ALIGN_CENTER_SELECTION</code></a></dd></dl>
</li>
</ul>
<a name="getAlignment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getAlignment</h4>
<pre>short&nbsp;getAlignment()</pre>
<div class="block">get the type of horizontal alignment for the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>align - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_GENERAL"><code>ALIGN_GENERAL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_LEFT"><code>ALIGN_LEFT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER"><code>ALIGN_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_RIGHT"><code>ALIGN_RIGHT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_FILL"><code>ALIGN_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_JUSTIFY"><code>ALIGN_JUSTIFY</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALIGN_CENTER_SELECTION"><code>ALIGN_CENTER_SELECTION</code></a></dd></dl>
</li>
</ul>
<a name="setWrapText(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setWrapText</h4>
<pre>void&nbsp;setWrapText(boolean&nbsp;wrapped)</pre>
<div class="block">Set whether the text should be wrapped.
 Setting this flag to <code>true</code> make all content visible
 whithin a cell by displaying it on multiple lines</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>wrapped</code> - wrap text or not</dd></dl>
</li>
</ul>
<a name="getWrapText()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getWrapText</h4>
<pre>boolean&nbsp;getWrapText()</pre>
<div class="block">get whether the text should be wrapped</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>wrap text or not</dd></dl>
</li>
</ul>
<a name="setVerticalAlignment(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setVerticalAlignment</h4>
<pre>void&nbsp;setVerticalAlignment(short&nbsp;align)</pre>
<div class="block">set the type of vertical alignment for the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>align</code> - the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><code>VERTICAL_TOP</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><code>VERTICAL_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><code>VERTICAL_BOTTOM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><code>VERTICAL_JUSTIFY</code></a></dd></dl>
</li>
</ul>
<a name="getVerticalAlignment()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getVerticalAlignment</h4>
<pre>short&nbsp;getVerticalAlignment()</pre>
<div class="block">get the type of vertical alignment for the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>align the type of alignment</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_TOP"><code>VERTICAL_TOP</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_CENTER"><code>VERTICAL_CENTER</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_BOTTOM"><code>VERTICAL_BOTTOM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#VERTICAL_JUSTIFY"><code>VERTICAL_JUSTIFY</code></a></dd></dl>
</li>
</ul>
<a name="setRotation(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRotation</h4>
<pre>void&nbsp;setRotation(short&nbsp;rotation)</pre>
<div class="block">set the degree of rotation for the text in the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>rotation</code> - degrees (between -90 and 90 degrees)</dd></dl>
</li>
</ul>
<a name="getRotation()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRotation</h4>
<pre>short&nbsp;getRotation()</pre>
<div class="block">get the degree of rotation for the text in the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>rotation degrees (between -90 and 90 degrees)</dd></dl>
</li>
</ul>
<a name="setIndention(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setIndention</h4>
<pre>void&nbsp;setIndention(short&nbsp;indent)</pre>
<div class="block">set the number of spaces to indent the text in the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>indent</code> - - number of spaces</dd></dl>
</li>
</ul>
<a name="getIndention()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getIndention</h4>
<pre>short&nbsp;getIndention()</pre>
<div class="block">get the number of spaces to indent the text in the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>indent - number of spaces</dd></dl>
</li>
</ul>
<a name="setBorderLeft(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderLeft</h4>
<pre>void&nbsp;setBorderLeft(short&nbsp;border)</pre>
<div class="block">set the type of border to use for the left border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderLeft()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderLeft</h4>
<pre>short&nbsp;getBorderLeft()</pre>
<div class="block">get the type of border to use for the left border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderRight(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderRight</h4>
<pre>void&nbsp;setBorderRight(short&nbsp;border)</pre>
<div class="block">set the type of border to use for the right border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderRight()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderRight</h4>
<pre>short&nbsp;getBorderRight()</pre>
<div class="block">get the type of border to use for the right border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderTop(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderTop</h4>
<pre>void&nbsp;setBorderTop(short&nbsp;border)</pre>
<div class="block">set the type of border to use for the top border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderTop()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderTop</h4>
<pre>short&nbsp;getBorderTop()</pre>
<div class="block">get the type of border to use for the top border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setBorderBottom(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBorderBottom</h4>
<pre>void&nbsp;setBorderBottom(short&nbsp;border)</pre>
<div class="block">set the type of border to use for the bottom border of the cell</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>border</code> - type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="getBorderBottom()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBorderBottom</h4>
<pre>short&nbsp;getBorderBottom()</pre>
<div class="block">get the type of border to use for the bottom border of the cell</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>border type</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_NONE"><code>BORDER_NONE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THIN"><code>BORDER_THIN</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM"><code>BORDER_MEDIUM</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASHED"><code>BORDER_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOTTED"><code>BORDER_DOTTED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_THICK"><code>BORDER_THICK</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DOUBLE"><code>BORDER_DOUBLE</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_HAIR"><code>BORDER_HAIR</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASHED"><code>BORDER_MEDIUM_DASHED</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT"><code>BORDER_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT"><code>BORDER_MEDIUM_DASH_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_DASH_DOT_DOT"><code>BORDER_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_MEDIUM_DASH_DOT_DOT"><code>BORDER_MEDIUM_DASH_DOT_DOT</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BORDER_SLANTED_DASH_DOT"><code>BORDER_SLANTED_DASH_DOT</code></a></dd></dl>
</li>
</ul>
<a name="setLeftBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setLeftBorderColor</h4>
<pre>void&nbsp;setLeftBorderColor(short&nbsp;color)</pre>
<div class="block">set the color to use for the left border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - The index of the color definition</dd></dl>
</li>
</ul>
<a name="getLeftBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getLeftBorderColor</h4>
<pre>short&nbsp;getLeftBorderColor()</pre>
<div class="block">get the color to use for the left border</div>
</li>
</ul>
<a name="setRightBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setRightBorderColor</h4>
<pre>void&nbsp;setRightBorderColor(short&nbsp;color)</pre>
<div class="block">set the color to use for the right border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - The index of the color definition</dd></dl>
</li>
</ul>
<a name="getRightBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getRightBorderColor</h4>
<pre>short&nbsp;getRightBorderColor()</pre>
<div class="block">get the color to use for the left border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the index of the color definition</dd></dl>
</li>
</ul>
<a name="setTopBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setTopBorderColor</h4>
<pre>void&nbsp;setTopBorderColor(short&nbsp;color)</pre>
<div class="block">set the color to use for the top border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - The index of the color definition</dd></dl>
</li>
</ul>
<a name="getTopBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getTopBorderColor</h4>
<pre>short&nbsp;getTopBorderColor()</pre>
<div class="block">get the color to use for the top border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>hhe index of the color definition</dd></dl>
</li>
</ul>
<a name="setBottomBorderColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setBottomBorderColor</h4>
<pre>void&nbsp;setBottomBorderColor(short&nbsp;color)</pre>
<div class="block">set the color to use for the bottom border</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>color</code> - The index of the color definition</dd></dl>
</li>
</ul>
<a name="getBottomBorderColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getBottomBorderColor</h4>
<pre>short&nbsp;getBottomBorderColor()</pre>
<div class="block">get the color to use for the left border</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>the index of the color definition</dd></dl>
</li>
</ul>
<a name="setFillPattern(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillPattern</h4>
<pre>void&nbsp;setFillPattern(short&nbsp;fp)</pre>
<div class="block">setting to one fills the cell with the foreground color... No idea about
 other values</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>fp</code> - fill pattern (set to 1 to fill w/foreground color)</dd><dt><span class="strong">See Also:</span></dt><dd><a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#NO_FILL"><code>NO_FILL</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SOLID_FOREGROUND"><code>SOLID_FOREGROUND</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#FINE_DOTS"><code>FINE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#ALT_BARS"><code>ALT_BARS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SPARSE_DOTS"><code>SPARSE_DOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_HORZ_BANDS"><code>THICK_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_VERT_BANDS"><code>THICK_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_BACKWARD_DIAG"><code>THICK_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THICK_FORWARD_DIAG"><code>THICK_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BIG_SPOTS"><code>BIG_SPOTS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#BRICKS"><code>BRICKS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_HORZ_BANDS"><code>THIN_HORZ_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_VERT_BANDS"><code>THIN_VERT_BANDS</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_BACKWARD_DIAG"><code>THIN_BACKWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#THIN_FORWARD_DIAG"><code>THIN_FORWARD_DIAG</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#SQUARES"><code>SQUARES</code></a>, 
<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html#DIAMONDS"><code>DIAMONDS</code></a></dd></dl>
</li>
</ul>
<a name="getFillPattern()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillPattern</h4>
<pre>short&nbsp;getFillPattern()</pre>
<div class="block">get the fill pattern (??) - set to 1 to fill with foreground color</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>fill pattern</dd></dl>
</li>
</ul>
<a name="setFillBackgroundColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillBackgroundColor</h4>
<pre>void&nbsp;setFillBackgroundColor(short&nbsp;bg)</pre>
<div class="block">set the background fill color.</div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>bg</code> - color</dd></dl>
</li>
</ul>
<a name="getFillBackgroundColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillBackgroundColor</h4>
<pre>short&nbsp;getFillBackgroundColor()</pre>
<div class="block">get the background fill color, if the fill
  is defined with an indexed color.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>fill color index, or 0 if not indexed (XSSF only)</dd></dl>
</li>
</ul>
<a name="getFillBackgroundColorColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillBackgroundColorColor</h4>
<pre><a href="../../../../../org/apache/poi/ss/usermodel/Color.html" title="interface in org.apache.poi.ss.usermodel">Color</a>&nbsp;getFillBackgroundColorColor()</pre>
<div class="block">Gets the color object representing the current
  background fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.</div>
</li>
</ul>
<a name="setFillForegroundColor(short)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setFillForegroundColor</h4>
<pre>void&nbsp;setFillForegroundColor(short&nbsp;bg)</pre>
<div class="block">set the foreground fill color
 <i>Note: Ensure Foreground color is set prior to background color.</i></div>
<dl><dt><span class="strong">Parameters:</span></dt><dd><code>bg</code> - color</dd></dl>
</li>
</ul>
<a name="getFillForegroundColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillForegroundColor</h4>
<pre>short&nbsp;getFillForegroundColor()</pre>
<div class="block">get the foreground fill color, if the fill  
  is defined with an indexed color.</div>
<dl><dt><span class="strong">Returns:</span></dt><dd>fill color, or 0 if not indexed (XSSF only)</dd></dl>
</li>
</ul>
<a name="getFillForegroundColorColor()">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>getFillForegroundColorColor</h4>
<pre><a href="../../../../../org/apache/poi/ss/usermodel/Color.html" title="interface in org.apache.poi.ss.usermodel">Color</a>&nbsp;getFillForegroundColorColor()</pre>
<div class="block">Gets the color object representing the current
  foreground fill, resolving indexes using
  the supplied workbook.
 This will work for both indexed and rgb
  defined colors.</div>
</li>
</ul>
<a name="cloneStyleFrom(org.apache.poi.ss.usermodel.CellStyle)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>cloneStyleFrom</h4>
<pre>void&nbsp;cloneStyleFrom(<a href="../../../../../org/apache/poi/ss/usermodel/CellStyle.html" title="interface in org.apache.poi.ss.usermodel">CellStyle</a>&nbsp;source)</pre>
<div class="block">Clones all the style information from another
  CellStyle, onto this one. This 
  CellStyle will then have all the same
  properties as the source, but the two may
  be edited independently.
 Any stylings on this CellStyle will be lost! 
  
 The source CellStyle could be from another
  Workbook if you like. This allows you to
  copy styles from one Workbook to another.

 However, both of the CellStyles will need
  to be of the same type (HSSFCellStyle or
  XSSFCellStyle)</div>
</li>
</ul>
<a name="setShrinkToFit(boolean)">
<!--   -->
</a>
<ul class="blockList">
<li class="blockList">
<h4>setShrinkToFit</h4>
<pre>void&nbsp;setShrinkToFit(boolean&nbsp;shrinkToFit)</pre>
<div class="block">Controls if the Cell should be auto-sized
  to shrink to fit if the text is too long</div>
</li>
</ul>
<a name="getShrinkToFit()">
<!--   -->
</a>
<ul class="blockListLast">
<li class="blockList">
<h4>getShrinkToFit</h4>
<pre>boolean&nbsp;getShrinkToFit()</pre>
<div class="block">Should the Cell be auto-sized by Excel to shrink
  it to fit if this text is too long?</div>
</li>
</ul>
</li>
</ul>
</li>
</ul>
</div>
</div>
<!-- ========= END OF CLASS DATA ========= -->
<!-- ======= START OF BOTTOM NAVBAR ====== -->
<div class="bottomNav"><a name="navbar_bottom">
<!--   -->
</a><a href="#skip-navbar_bottom" title="Skip navigation links"></a><a name="navbar_bottom_firstrow">
<!--   -->
</a>
<ul class="navList" title="Navigation">
<li><a href="../../../../../overview-summary.html">Overview</a></li>
<li><a href="package-summary.html">Package</a></li>
<li class="navBarCell1Rev">Class</li>
<li><a href="class-use/CellStyle.html">Use</a></li>
<li><a href="package-tree.html">Tree</a></li>
<li><a href="../../../../../deprecated-list.html">Deprecated</a></li>
<li><a href="../../../../../index-all.html">Index</a></li>
<li><a href="../../../../../help-doc.html">Help</a></li>
</ul>
</div>
<div class="subNav">
<ul class="navList">
<li><a href="../../../../../org/apache/poi/ss/usermodel/CellRange.html" title="interface in org.apache.poi.ss.usermodel"><span class="strong">PREV CLASS</span></a></li>
<li><a href="../../../../../org/apache/poi/ss/usermodel/CellValue.html" title="class in org.apache.poi.ss.usermodel"><span class="strong">NEXT CLASS</span></a></li>
</ul>
<ul class="navList">
<li><a href="../../../../../index.html?org/apache/poi/ss/usermodel/CellStyle.html" target="_top">FRAMES</a></li>
<li><a href="CellStyle.html" target="_top">NO FRAMES</a></li>
</ul>
<ul class="navList" id="allclasses_navbar_bottom">
<li><a href="../../../../../allclasses-noframe.html">All Classes</a></li>
</ul>
<div>
<script type="text/javascript"><!--
  allClassesLink = document.getElementById("allclasses_navbar_bottom");
  if(window==top) {
    allClassesLink.style.display = "block";
  }
  else {
    allClassesLink.style.display = "none";
  }
  //-->
</script>
</div>
<div>
<ul class="subNavList">
<li>SUMMARY:&nbsp;</li>
<li>NESTED&nbsp;|&nbsp;</li>
<li><a href="#field_summary">FIELD</a>&nbsp;|&nbsp;</li>
<li>CONSTR&nbsp;|&nbsp;</li>
<li><a href="#method_summary">METHOD</a></li>
</ul>
<ul class="subNavList">
<li>DETAIL:&nbsp;</li>
<li><a href="#field_detail">FIELD</a>&nbsp;|&nbsp;</li>
<li>CONSTR&nbsp;|&nbsp;</li>
<li><a href="#method_detail">METHOD</a></li>
</ul>
</div>
<a name="skip-navbar_bottom">
<!--   -->
</a></div>
<!-- ======== END OF BOTTOM NAVBAR ======= -->
<p class="legalCopy"><small>
                <i>Copyright 2014 The Apache Software Foundation or
        its licensors, as applicable.</i>
            </small></p>
</body>
</html>
